

--on insere tous les departements de france:

INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Ain');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Aisne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Allier');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Alpes-Haute-Provence');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Hautes-Alpes');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Alpes-Maritimes');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Ardeche');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Ardennes');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Ariege');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Aube');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Aude');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Aveyron');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Bouches-du-Rhone');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Calvados');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Cantal');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Charente');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Charente-Maritime');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Cher');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Correze');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Cote-dOr');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Cotes-dArmor');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Creuse');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Dordogne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Doubs');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Drome');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Eure');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Eure-et-Loir');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Finistere');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Gard');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Garonne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Gers');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Gironde');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Herault');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Ille-et-Vilaine');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Indre');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Indre-et-Loire');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Isere');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Jura');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Landes');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Loir-et-Cher');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Loire');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Loire');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Loire-Atlantique');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Loiret');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Lot');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Lot-et-Garonne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Lozere');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Maine-et-Loire');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Manche');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Marne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Marne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Mayenne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Meurthe-et-Moselle');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Meuse');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Morbihan');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Moselle');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Nievre');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Nord');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Oise');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Orne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Pas-de-Calais');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Puy-de-Dome');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Pyrenees-Atlantiques');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Hautes-Pyrenees');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Pyrenees-Orientales');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Bas-Rhin');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haut-Rhin');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Rhone');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Saone');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Saone-et-Loire');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Sarthe');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Savoie');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Savoie');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Paris');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Seine-Maritime');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Seine-et-Marne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Yvelines');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Deux-Sevres');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Somme');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Tarn');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Tarn-et-Garonne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Var');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Vaucluse');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Vendee');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Vienne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Haute-Vienne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Vosges');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Yonne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Territoire Belfort');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Essonne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Hauts-de-Seine');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Seine-Saint-Denis');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Val-de-Marne');
INSERT INTO Departement (NumDept, NomDept)
       VALUES (seqnumdept.nextval, 'Val-dOise');
